@echo off

Set /P DBNAME=[Enter database Name:] 
Set /P USERNAME=[Enter database UserID:] 
Set /P PASSWORD=[Enter database Password:] 
Set /P SERVERINSTANCE=[Enter Server Name:] 

@Echo -
@Echo.:: Using the following setup values:
@Echo DataBaseName is %DBNAME%
@Echo Username is %USERNAME%
@Echo Password is %PASSWORD%
@Echo Server is %SERVERINSTANCE%
@Echo -
@Pause

Echo.

sqlcmd -U %USERNAME% -P %PASSWORD% -S %SERVERINSTANCE% -d %DBNAME% -i SQLQuery_DropTables.sql

sqlcmd -U %USERNAME% -P %PASSWORD% -S %SERVERINSTANCE% -d %DBNAME% -i SQLQuery_CreateTables.sql

sqlcmd -U %USERNAME% -P %PASSWORD% -S %SERVERINSTANCE% -d %DBNAME% -i SQLQuery_CustomFunctions.sql

sqlcmd -U %USERNAME% -P %PASSWORD% -S %SERVERINSTANCE% -d %DBNAME% -i SQLQuery_StoredProcs.sql

sqlcmd -U %USERNAME% -P %PASSWORD% -S %SERVERINSTANCE% -d %DBNAME% -i SQLQuery_Views.sql

sqlcmd -U %USERNAME% -P %PASSWORD% -S %SERVERINSTANCE% -d %DBNAME% -i SQLQuery_Search.sql

Echo.
@Pause
